from datetime import datetime

from sqlalchemy import Boolean, Column, Integer,VARCHAR,VARBINARY,SmallInteger,BIGINT,DateTime,Foreignkey
from api.db.base_class import Base,gen_uuid

# 班级表
class Sclass(Base):
    __tablename__ = 'sclass'
    name = Column(VARCHAR(30), unique=True, comment='班级名称')


# 学生表
class Student(Base):
    __tablename__ = 'student'
    name = Column(VARCHAR(30), unique=True, comment='班级名称')
    cid = Column(Integer,Foreignkey("sclass.id"),comment='班级id')

# 课程表
class Coures(Base):
    __tablename__ = 'coures'
    name = Column(VARCHAR(30), unique=True, comment='课程表')


# 课程选项表
class StuCourse(Base):
    __tablename__ = 'stu_course'
    sid = Column(Integer, Foreignkey("student.id"), comment='学生id')
    cid = Column(Integer, Foreignkey("course.id"), comment='课程id')

















